package com.isec.base.monit.dao;

import org.springframework.stereotype.Repository;

import com.core.security.database.jdbc.BaseDao;
import com.isec.base.monit.dto.PmDto;

@Repository
public class PmDao extends BaseDao<PmDto, String>{

	public PmDto getLastPmData() {
			
		return this.getObject("SELECT * FROM (SELECT A.*,B.DATAINDEX FROM IDGAR_PM_TAB A,IGDAR_DATALOG_TAB B WHERE A.PM_ID = B.DATAID AND B.DATATYPE = '1') T ORDER BY T.DATAINDEX DESC LIMIT 1");
	}
}
